package com.feri.fs.provider.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.feri.fs.provider.entity.UserProject;
import common.dto.ProjectDetailDto;
import org.apache.ibatis.annotations.Select;

/**
 * @ClassName UserProjectDao
 * @Description TODO
 * @Author xing
 * @Date 2021/11/9 09:47
 * @Version 1.0
 */
public interface UserProjectDao extends BaseMapper<UserProject> {
    @Select("select up.*,ps.objname,ps.srcurl,ps.etime from t_userproject up inner join t_projectsrc ps on up.id=ps.pid where up.id=#{id}")
    ProjectDetailDto selectId(int id);


}
